SAP Data Source

Please enter the following parameters to connect to a SAP data source:

• Alias: name of the data source to be used in CData Virtuality Server
• Endpoint: SAP connection URL

SAP connection parameters

1. Connect to the driver (press the "Connect" button).

2. To add a new extraction press the "New" button.

3. Enter the name for the new extraction and select the type "SAP Table or View".

4. Select "Shared Connection" and press the "..." button to create a connection.

5. Press the "New" button.

6. Fill the connection parameters like in the screenshot.

7. To select a table press the binoculars button.

8. Set up the filter (or just leave it as it is) and press the binoculars button.

9. Select a table from the list and press the "OK" button.

10. Select the table fields (projection) you want to extract and set WHERE-conditions (optional) and press the "OK" button.

11. See the newly created table extraction in the list.

Only those tables that were configured with Xtract Universal can be seen using CData Virtuality.

Here's the SQL code to connect to SAP using the translator:

call createConnection('sap1', 'ws', 'EndPoint=http://localhost:8065/');
call createDatasource('sap1', 'sap', null, null);